REM  SQL scripts for Appendix B of ORACLE8 DBA Handbook by Kevin Loney.
REM  See www.osborne.com for updates to these scripts.



> cd $ORACLE_HOME/otrace/admin
> ls -alt *.dat

> cd $ORACLE_HOME/otrace/admin
> rm -f process.dat regid.dat
> otrccref


EPC_DISABLED=TRUE; export EPC_DISABLED



SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = loc)
      (ORACLE_HOME = /orasw/app/oracle/product/8.0.3.1)
    )
  )


SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = loc)
      (ORACLE_HOME = /orasw/app/oracle/product/8.0.3.1)
      (ENVS='EPC_DISABLED=TRUE')
    )
  )


alter tablespace REPOS_TS
default storage (initial 20K next 20K pctincrease 0 
                 maxextents 250);


orapwd file=$ORACLE_HOME/dbs/orapwCC1 password=wwywwyl

REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE


#tnsnames.ora:
dbsnmp.world = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hq)(PORT=1528)))

#topology.ora
cc1.world = (ORACLE_DATABASE,hq, LISTENER_hq.world)
dbsnmp.world = (ORACLE_AGENT,hq)
listener.world = (ORACLE_LISTENER, hq)

#snmp.ora:
snmp.visibleservices = (cc1.world)
snmp.ORACLE_HOME.cc1.world=/orasw/app.oracle/product/8.0.3.0
snmp.INDEX.cc1.world = 1
snmp.CONTACT.cc1.world = "Your Name Here"
snmp.SID.cc1.world = cc1
snmp.CONNECT.cc1.world.name = dbsnmp
snmp.CONNECT.cc1.world = dbsnmp
nmi.trace_level = off
nmi.trace_mask = (106)
dbsnmp.address = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hq)(PORT=1528)))
dbsnmp.spawnaddress=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hq)(PORT=1529)))



dbsnmp.address = (DESCRIPTION=(ADDRESS=
(COMMUNITY=unix.world)(PROTOCOL=tcp)(HOST=hq)(PORT=1528)))
dbsnmp.spawnaddress=(DESCRIPTION=(ADDRESS=(
COMMUNITY=unix.world)(PROTOCOL=tcp)(HOST=hq)(PORT=1529)))




